package com.caifu.mapper;

import com.caifu.pojo.YlBuilding;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author GZ
 * @since 2020-11-05
 */
public interface YlBuildingMapper extends BaseMapper<YlBuilding> {
    /**
    * 
    * 功能描述：根据名称查询楼苑信息
    * 
    * @Param buildingName 楼苑名称 pensionNo养老机构编号
    * @Return      
    * @Exception   
    * @Author  GZ
    * @Date   2020/11/6 10:16
    */
    @Select({"<script>",
            "select * from yl_building b where  b.BUILDING_STATE='1'",
            "and b.BUILDING_NAME=#{buildingName} and b.PENSION_NO =#{pensionNo}",
            "</script>"
    })
    YlBuilding queryBuildingInfoByName(String buildingName,String pensionNo);
}
